Introduction
Double-entry bookkeeping is the heart of reliable accounting. It ensures that every transaction is recorded twice — once as a debit and once as a credit — which keeps the books balanced and makes errors easier to find. In this article you’ll learn the practical steps: how to record journal entries, post them to ledgers (T-accounts), prepare a trial balance, and see how the numbers flow into financial statements. A downloadable spreadsheet with the example shown below is provided to help you practice.
Why double-entry matters (simple reasons)
- It enforces the accounting equation: Assets = Liabilities + Equity.
- It provides a built-in check: total debits must equal total credits.
- It produces an audit trail: you can trace every balance back to original entries.
- It supports preparation of financial statements automatically when balances are correct.
The basic journal entry format
A journal entry records:
- The date,
- The accounts affected (which account is debited and which is credited),
- The amount, and
- A short description.
Standard layout (simplified):
- Debit: [Account A] — $X
- Credit: [Account B] — $X
- Description: …
Tip: Always write a clear description (who/what/why) — it helps when reviewing months later.
Example — Small Coffee Cart (one-month transactions)
We’ll use a simple, realistic set of transactions for a coffee cart during its first month. (The same example appears in the downloadable spreadsheet.)
Transactions:
- 2026-01-01 — Owner invests cash: Debit Cash $1,000; Credit Owner’s Capital $1,000.
- 2026-01-03 — Purchased equipment for cash: Debit Equipment $400; Credit Cash $400.
- 2026-01-05 — Bought inventory on credit: Debit Inventory $200; Credit Accounts Payable $200.
- 2026-01-10 — Cash sales: Debit Cash $800; Credit Sales Revenue $800.
- 2026-01-10 — Record Cost of Goods Sold (COGS): Debit COGS $120; Credit Inventory $120.
- 2026-01-20 — Paid operating expenses: Debit Operating Expenses $80; Credit Cash $80.
- 2026-01-25 — Owner withdraws cash: Debit Drawings $100; Credit Cash $100.
These entries are recorded on the Journal sheet in the spreadsheet.
Posting to the ledger (T-accounts) — how balances are built
After recording in the journal you post each debit and credit to the ledger. The ledger groups all transactions by account and shows running balances.
Example ledger posts (abridged):
Cash T-account:
- Debit $1,000 (owner investment) → balance $1,000
- Credit $400 (equipment) → balance $600
- Debit $800 (sales) → balance $1,400
- Credit $80 (expenses) → balance $1,320
- Credit $100 (drawings) → balance $1,220
Equipment T-account:
- Debit $400 → balance $400
Inventory T-account:
- Debit $200 → balance $200
- Credit $120 (COGS) → balance $80 (ending inventory)
Accounts Payable T-account:
- Credit $200 → balance $200
Sales Revenue T-account:
- Credit $800 → balance (credit) $800
COGS T-account:
- Debit $120 → balance $120
Operating Expenses T-account:
- Debit $80 → balance $80
Drawings T-account:
- Debit $100 → balance $100
The spreadsheet’s “Ledger” sheet shows each posting and a running balance for every account.
Trial Balance — check that debits = credits
Once all ledger balances are computed, prepare a trial balance listing each account with its ending debit or credit balance. The totals of the Debit column and Credit column must match. If they don’t, you need to find posting or journal errors.
For our example the Trial Balance matches (you can verify in the spreadsheet).
From trial balance to financial statements
Use the trial balance balances to prepare:
- Income Statement: includes revenues and expenses to compute Net Income.
- Sales Revenue (credit) = $800
- COGS (debit) = $120
- Operating Expenses (debit) = $80
- Net Income = $800 − ($120 + $80) = $600
- Balance Sheet: lists assets, liabilities, and equity at period end.
- Assets: Cash $1,220 + Equipment $400 + Inventory $80 = $1,700
- Liabilities: Accounts Payable = $200
- Equity: Owner’s Capital $1,000 + Net Income $600 − Drawings $100 = $1,500
- Liabilities + Equity = $200 + $1,500 = $1,700 (balances with assets)
The spreadsheet includes Income Statement and Balance Sheet sheets that pull values from the trial balance so you can see the flow instantly.
Common mistakes and quick checks
- Journal totals don’t equal: ensure each entry has equal debit and credit amounts.
- Wrong account type: e.g., recording an asset purchase as an expense will distort profit.
- Posting errors: ensure every journal line is posted to the ledger.
- Transposition errors: 540 vs 450 — check arithmetic or use the trial balance to find the difference pattern.
- Missing dates: chronological order helps tracing when reviewing.
Use the trial balance as your first reconciliation tool.
How to use the downloadable spreadsheet
- Download the file (link above).
- Open the Journal sheet and review the example entries. Replace or add your own transactions.
- The Ledger sheet will show postings and running balances (it’s auto-generated from the Journal).
- Check Trial Balance totals — Debits must equal Credits.
- Review the Income Statement and Balance Sheet sheets — they update based on the trial balance.
Notes:
- The spreadsheet is designed for learning and small-business use. For live businesses, consider accounting software (QuickBooks, Xero) as volume grows.
- If you want a Google Sheets version, tell me and I’ll convert it.
SEO & Publication Metadata
SEO Title: Double-Entry Bookkeeping — Journal Entries & Ledgers (Part 3)
Meta Description: Learn double-entry bookkeeping with practical journal entries, ledger postings, and a downloadable Excel template. Follow a small coffee-cart example step-by-step.
Suggested slug: double-entry-bookkeeping-journal-ledger-template